"PLAN_TABLE_OUTPUT"
"Plan hash value: 3652590185"
" "
"---------------------------------------------------------------------------------------------------"
"| Id  | Operation            | Name                       | Rows  | Bytes | Cost (%CPU)| Time     |"
"---------------------------------------------------------------------------------------------------"
"|   0 | SELECT STATEMENT     |                            |  1112 | 31136 |    10  (20)| 00:00:01 |"
"|   1 |  RESULT CACHE        | 3anmja8pzpa8kc5f0pw7hdfjju |       |       |            |          |"
"|   2 |   HASH GROUP BY      |                            |  1112 | 31136 |    10  (20)| 00:00:01 |"
"|*  3 |    HASH JOIN         |                            |  1112 | 31136 |     9  (12)| 00:00:01 |"
"|   4 |     TABLE ACCESS FULL| PRODUCT_INFORMATION        |   288 |  5760 |     5   (0)| 00:00:01 |"
"|   5 |     TABLE ACCESS FULL| INVENTORIES                |  1112 |  8896 |     3   (0)| 00:00:01 |"
"---------------------------------------------------------------------------------------------------"
" "
"Predicate Information (identified by operation id):"
"---------------------------------------------------"
" "
"   3 - access(""INVENTORIES"".""PRODUCT_ID""=""PRODUCT_INFORMATION"".""PRODUCT_ID"")"
" "
"Result Cache Information (identified by operation id):"
"------------------------------------------------------"
" "
"   1 - column-count=4; dependencies=(OE.INVENTORIES, OE.PRODUCT_INFORMATION); parameters=(nls); name=""SELECT /*+ result_cache */ count(*), round(avg(quantity_on_hand)) AVG_AMT, product_id, product_name
  FROM inventories natural j"""